{\rtf1\ansi\ansicpg1252\cocoartf1138\cocoasubrtf230
{\fonttbl\f0\fswiss\fcharset0 Helvetica;}
{\colortbl;\red255\green255\blue255;}
\margl1440\margr1440\vieww25100\viewh14520\viewkind0
\pard\tx720\tx1440\tx2160\tx2880\tx3600\tx4320\tx5040\tx5760\tx6480\tx7200\tx7920\tx8640\pardirnatural

\f0\b\fs24 \cf0 TOTAL TRANSFER TXNS = 1677\
Transfer transactions between checking and other accounts(1674)
\b0 \
select txn_id,from_acc_id,to_acc_id,amount,year(txn_date) year, month(txn_date) month, day(txn_date) day \
from `biswasm_accounting`.`transactions` \
where txn_type='A' and proxy_txn='N' \
\

\b Transfer transactions between non-checking accounts (3)\

\b0 select a.txn_id,a.from_acc_id,b.to_acc_id,a.amount,year(a.txn_date) year, month(a.txn_date) month, day(a.txn_date) day \
from `biswasm_accounting`.`transactions` a, `biswasm_accounting`.`transactions` b \
where a.txn_type='A' and a.proxy_txn='Y' and a.proxy_txn_id not in\
(select c.txn_id from `biswasm_accounting`.`transactions` c where c.txn_type in ('I','E'))\
and a.to_acc_id=1 and b.proxy_txn_id=a.txn_id;\
\

\b TOTAL EXPENSE TXNS = 5095
\b0 \

\b Expense transactions from non-checking accounts(1433)\

\b0 select a.txn_id,a.entity_id,b.from_acc_id,a.amount,year(a.txn_date) year, month(a.txn_date) month, day(a.txn_date) day \
from `biswasm_accounting`.`transactions` a, `biswasm_accounting`.`transactions` b \
where a.txn_type='E' and a.proxy_txn='Y' \
and a.from_acc_id=1 and b.proxy_txn_id=a.txn_id;\

\b \
Expense transactions from checking account(3662)\

\b0 select txn_id,entity_id,from_acc_id,amount,year(txn_date) year, month(txn_date) month, day(txn_date) day \
from `biswasm_accounting`.`transactions` \
where txn_type='E' and proxy_txn='N' \

\b \
TOTAL INCOME TXNS = 921\
Income transactions to non-checking accounts(718)\

\b0 select a.txn_id,a.entity_id,b.to_acc_id,a.amount,year(a.txn_date) year, month(a.txn_date) month, day(a.txn_date) day \
from `biswasm_accounting`.`transactions` a, `biswasm_accounting`.`transactions` b \
where a.txn_type='I' and a.proxy_txn='Y' \
and a.to_acc_id=1 and b.proxy_txn_id=a.txn_id;\

\b \
Income transactions to checking account(203)\

\b0 select txn_id,entity_id,to_acc_id,amount,year(txn_date) year, month(txn_date) month, day(txn_date) day \
from `biswasm_accounting`.`transactions` \
where txn_type='I' and proxy_txn='N' \
\
MONTH END BALANCE AND MONTHLY CAT TOTAL TO BE DERIVED FROM TRANSACTIONS\
}